Navigator Accounts Payable Inquiry

Associated Files

Running an AP Inquiry

AP Ledger

AP History

Template Accounts

Printing Reports

Associated Files

• Access to all Navigator applications can be granted or restricted globally, by authority class, or by user. Global settings (NAV 1) are the initial settings, Authority Class settings (NAV 2) override the global settings, and User settings (NAV 5) override both global and authority class.

Running an AP Inquiry

When you first access the program you are presented with a filters screen. Using the Filters dialog box, inquiries can be made across all the AP accounts based on your specific parameters. For example, a report can be generated that list regular invoices for a particular time-frame (Post Month/Year).

Entering different search parameters in the Filters Tab can take you to different parts of the AP Inquiry screen.

• Not entering an account number takes you to the complete listing.

• Entering only a company and a vendor or supplier takes you to the AP Ledger screen.

  

AP Ledger

The AP Ledger Screen program shows all open payables for each vendor account on the system. The ledger includes open, current monthly activity.

Notes

• The transactions are initially sequenced by vendor's invoice date. However, clicking on a column heading rearranges the information in either ascending or descending order based on that heading.
• Items with the same vendor invoice date are sequenced by voucher number. Items expensed to two or more expense accounts appear on two or more separate lines, each having the same voucher number.
• Each open payable is on a separate line.
• The aging parameters give you a dollar summary of your past due payments.
• The Invoice Transaction Codes represent the processing of any cash disbursement made for this item. The available codes are:



• A complete list of the Invoice Paid Transaction codes can be obtained by running the AP Transaction Codes List (menu option AP 204).

• The Paid Transaction Codes represent how payables are processed.

  This Paid Date can show one of two dates:

  • If no payment has been received, the date that the item is scheduled to be paid displays.
  • If a payment has been received, the check date displays.

  AP History

  This option presents a chronological history by accounting month and date for each vendor or supplier. This program shows each transaction, including invoices, credits, adjustments, and payments. It also shows which invoices were paid and the check numbers.

  Notes:

  • The Cash Account, AP Account, Branch, and Cost Center are defaulted in from the Vendor or the Supplier Files.
  • The Invoice and Paid Transaction codes used are the same codes used in the AP Led­ger.
  • The Manifest Number is manually assigned via the Enter Receipts program (menu option INB 1) when inventory is received. This number can be used to match A/P invoices to receipts before or after vouchering them.

  Template Accounts

  This tab imports default information in from the Supplier or Vendor File. When you create a Supplier/Vendor Template, it becomes the default A/P Entry screen for all invoices entered for the supplier.

  If the invoices for this supplier are in a foreign currency, you can also view the default exchange rate account numbers and cost centers for A/P.

  To use the exchange rate feature, you must first set up the Exchange Rate Table and the Supplier Currency Code Table in the System Settings Menu.

  Notes:

  • The information at the top comes straight from the Supplier or Vendor File.
  • The Group Code, in the top part of the screen, allows you to assign a supplier/vendor to a group. This grouping provides another level of organization of payments. For example, you can group vendors by the type of product or service they provide, and generate checks by group. You can set up groups for installers, import suppliers, domestic suppliers, etc.
    • Supplier/Vendor groups are established via ACT 120.
  • The Policy Codes, in the top part of the screen, are assigned in the Supplier or Vendor file. They trigger special processing or identify certain suppliers or situations. These can be user-assigned or assigned by KerridgeNC. Some examples are:

  

  • The setting Invoice Amount in Foreign Currency, if activated, denotes that this vendor/supplier's invoices are processed in foreign currency. If activated, the fields Default Exchange Payable Account and Cost Center and Default Exchange Clearing Account and Cost Center must also have entries.

  • The Amount, Discount, Description, Acct, Brn, and Cctr fields display established defaults for the supplier or vendor's invoices.

  • If you get an recurring invoice that is the same every month (e.g. from your internet provider or a contractor) you can enter the amount and the rest of the information. This will save you steps in having to reenter the information every month.

  • If the amount varies from month to month, do not enter an amount, but the rest of the fields can be used.

  • A Y entry in the Suppress column directs the system to suppress any discounts for this line.

  Printing Reports

  1. The first step after clicking Print Report is to give the report a file name and change the description if needed.
  2. Click Continue to generate the report.
  3. The reports are retrieved by clicking the ODS link in the top-right corner. In ODS, access the IFS Reports and select your report to open it as a spreadsheet.